﻿-- =============================================
-- Author:		<赵洪涛>
-- Create date: <2014-08-25>
-- Description:	<WebService通过用户名返回员工状态>
-- =============================================
Create PROCEDURE [dbo].[proc_WebService_GetEmployeeState] 
(
	@UserId varchar(10)
)
AS
BEGIN
	Declare @nState int

	Select Top 1 @nState=State From Employee Where UserName=@UserId
	Select IsNull(@nState,-1) As State
END